package com.leyou.dao;

import com.leyou.pojo.Spec_param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface Spec_paramMapper extends Mapper<Spec_param> {
    @Select("select * from tb_spec_param where group_id=#{gid}")
    List<Spec_param> params(Integer gid);
   @Select("select * from tb_spec_param where cid=#{cid} ")
    List<Spec_param> selectByCid(Integer cid);
    @Select("select * from tb_spec_param where cid=#{cid} and searching=true")
    List<Spec_param> selectByCidAndSearching(Integer cid);
    @Select("select * from tb_spec_param where cid=#{cid} and generic=false")
    List<Spec_param> fingParamByCidAndGeneric(Integer cid);
}
